﻿using NPOI.SS.UserModel;
using System.Collections;
using System.Collections.Generic;
using UnityEditor;
using UnityEngine;

namespace Smart.Editor
{
    public static class ExcelOperation
    {
        [MenuItem("Tools/表格/转表")]
        public static void Test()
        {
            ExcelConvert converter = new ExcelConvert();
            converter.LoadFile(GetExcelPath("UnionBuff.xls"),0);
        }

        public static string GetExcelPath(string excelName)
        {
            excelName = System.IO.Path.GetFileNameWithoutExtension(excelName);
            excelName = $"{Application.dataPath}/../../Table/{excelName}.xls";
            return excelName;
        }
    }
}